home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presentation Library 1993 Spring / ARPL-Spring-93-Partner-Edition.iso / Applications / Databases / GQL V3.0 Demo / USA Sales Information / USA Sales Information.rsrc / gDEM_8145_Eastern Sales by City < prev    next >
Encoding:
Text File  |  1992-01-27  |  253 b   |  1 lines
  1. select customer.cust_city, AVG (orders.ord_amount) from customer, orders where ((customer.cust_state IN ('MI','IN','PA','NY','NH','ME','KY','MA','TN','NC','SC','GA','FL'))) and customer.cust_num = orders.cust_nr group by customer.cust_city order by 1 ;